﻿/*
Deployment script for CodeflowsDemo
*/

GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER ON;

SET CONCAT_NULL_YIELDS_NULL, NUMERIC_ROUNDABORT OFF;


GO
:setvar DatabaseName "CodeflowsDemo"
:setvar DefaultDataPath "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\"
:setvar DefaultLogPath "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\"

GO
:on error exit
GO
USE [master]
GO
USE [$(DatabaseName)]
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
GO
BEGIN TRANSACTION
GO
PRINT N'Dropping [SqlServerCodeflowDispatcher].[SqlAssemblyProjectRoot]...';


GO
EXECUTE sp_dropextendedproperty @name = N'SqlAssemblyProjectRoot', @level0type = N'Assembly', @level0name = N'SqlServerCodeflowDispatcher';


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Dropping [dbo].[DispatchCodeflow]...';


GO
DROP PROCEDURE [dbo].[DispatchCodeflow];


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Dropping [SqlServerCodeflowDispatcher]...';


GO
DROP ASSEMBLY [SqlServerCodeflowDispatcher];


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Creating [SqlServerCodeflowDispatcher]...';


GO
CREATE ASSEMBLY [SqlServerCodeflowDispatcher]
    AUTHORIZATION [dbo]
    FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103008EF71B4F0000000000000000E00002210B0108000014000000060000000000002E330000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000DC3200004F00000000400000C803000000000000000000000000000000000000006000000C0000003C3200001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000034130000002000000014000000020000000000000000000000000000200000602E72737263000000C8030000004000000004000000160000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001A00000000000000000000000000004000004200000000000000000000000000000000103300000000000048000000020005004C230000F00E000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B3003005700000001000011000316547201000070731000000A0A00066F1100000A000F00FE16030000016F1200000A06120128020000060C082D02DE2303070628030000062D03162B01175400DE100614FE010C082D07066F1300000A00DC00002A000110000002000F0035440010000000001B300300D00000000200001100041451731400000A0D09036F1500000A000972310000706F1600000A00090A140B00066F1700000A751B0000010B00DE280C0008280700000616FE01130511052D02FE1A72C600007008281800000A0328050000060000DE00000714FE0116FE01130511052D1200725D010070032805000006001613042B53070772CB0100706F1900000A2D1A0772CF0100706F1900000A2D0D72CF01007002281A00000A2B0102281A00000A0B071704281B00000A130511052D110072D30100702804000006001613042B051713042B0011042A011000000000220010320028060000011B30020046000000030000110000731C00000A0A06026F1D00000A26170DDE2F0B0007280700000616FE01130411042D02FE1A722F02007007281800000A0C080328050000060000DE0000160D2B0000092A000001100000000001001314002A060000011B3002002C0000000400001100731E00000A0A00066F1100000A00020628050000060000DE100614FE010B072D07066F1300000A00DC002A0110000002000700131A0010000000002E000219032806000006002A1B30030079000000050000110000731400000A0B07046F1500000A000772BE0200706F1600000A00070A066F1F00000A7245030070026F2000000A26066F1F00000A7251030070038C020000026F2000000A26066F2100000A2600DE260C0008280700000616FE010D092D02FE1A72630300700208282200000A282300000A0000DE00002A00000001100000000001005051002606000001133002003800000006000011000275210000012D290275220000012D210275230000012D190275240000012C0E02752500000114FE0316FE012B01162B01170A2B00062A1E02282400000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000D4030000237E0000400400005005000023537472696E67730000000090090000F403000023555300840D0000100000002347554944000000940D00005C01000023426C6F620000000000000002000001571D02000900000000FA25330016000001000000250000000300000005000000080000000E00000024000000040000000C00000006000000010000000300000000000A0001000000000006006F0068000600740068000600A60068000A00DE00C8000E00EC00680006001C01680006006D014E010600D201C0010600E901C00106000602C00106002502C00106003E02C00106005702C00106007202C00106008D02C0010600A6024E010600BA02C0010600E602D3024B00FA0200000600290309030600490309030A00820367030A00AB0398030600C60368000A00DA03C8000A00F403980306001C0468000E003A0468000E0057044C040A006E04C8000A009404C8000E00BE04D3020600DB04CA040600F0044E0106000D05FD0406001F0568000600340568000000000001000000000001000100000100002A003200050001000100010010004E00000009000600010006067B000A00568083000D0056808C000D00568098000D005680A0000D005020000000009600AB0025000100C420000000009100F0002D000300B02100000000910002013700060014220000000091000F013F0008005C220000000091000F0144000900682200000000910018014B000B000023000000009100260154000E0044230000000086182E015A000F00000001003401020002004701000001003401000002007A01020003008501000001009701000002007A0100000100A60100000100A601000002007A0100000100A60100000200AE01000003007A0100000100B60139002E015A0041002E015E0049002E015E0051002E015E0059002E015E0061002E015E0069002E015E0071002E015E0079002E015E0081002E01630089002E015E0091002E016800A1002E016E00A9002E015A00B1002E015A0021002E015E00B900B8035A001100BD037300C100D2035A00C9002E015A00C900E5037F00D100FE035E00D1000E048500D90023048900D9002A048F00D90033049400290042049A00E9002E015A00E9006104B00021002E015A00C9008504C700F100A104CC00D100AE04D300D9002304D7000101C4043F0011002E015A0008000800110008000C001600080010001B0008001400200020007B0016002E003300EC002E001B000D012E0023000D012E002B000D012E001300EC002E003B0013012E0043000D012E0053000D012E0063002B012E006B0034012E0073003D017700A400B700C100DE00E8000480000001000000341157990000000000003200000002000000000000000000000001005F00000000000200000000000000000000000100BC000000000002000000000000000000000001006800000000000000003C4D6F64756C653E0053716C536572766572436F6465666C6F77446973706174636865722E646C6C004C6F67547970650053716C536572766572436F6465666C6F77446973706174636865720053746F72656450726F63656475726573006D73636F726C69620053797374656D00456E756D004F626A6563740076616C75655F5F0056657273626F736500496E666F726D6174696F6E005761726E696E67004572726F720047756964004469737061746368436F6465666C6F770053797374656D2E446174610053797374656D2E446174612E53716C436C69656E740053716C436F6E6E656374696F6E0055726900476574576F726B6572456E64706F696E74004469737061746368436F7265004C6F674572726F72004C6F6700457863657074696F6E004973466174616C002E63746F7200636F6465666C6F77496E7374616E6365496400726573756C740053797374656D2E52756E74696D652E496E7465726F705365727669636573004F757441747472696275746500636F6E6E656374696F6E00776F726B6572456E64706F696E7455726900776F726B6572456E64706F696E74006D657373616765006C6F675479706500657863657074696F6E0053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C7475726541747472696275746500436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465004D6963726F736F66742E53716C5365727665722E5365727665720053716C50726F6365647572654174747269627574650053797374656D2E446174612E436F6D6D6F6E004462436F6E6E656374696F6E004F70656E00546F537472696E670049446973706F7361626C6500446973706F73650053716C436F6D6D616E64007365745F436F6E6E656374696F6E004462436F6D6D616E64007365745F436F6D6D616E645465787400457865637574655363616C617200537472696E6700466F726D617400456E64735769746800436F6E636174005572694B696E64005472794372656174650053797374656D2E4E657400576562436C69656E7400446F776E6C6F6164446174610053716C506172616D65746572436F6C6C656374696F6E006765745F506172616D65746572730053716C506172616D65746572004164645769746856616C756500457865637574654E6F6E51756572790054726163650057726974650053797374656D2E546872656164696E670054687265616441626F7274457863657074696F6E00534548457863657074696F6E0053797374656D2E5365637572697479005365637572697479457863657074696F6E004F75744F664D656D6F7279457863657074696F6E00496E73756666696369656E744D656D6F7279457863657074696F6E00002F63006F006E007400650078007400200063006F006E006E0065006300740069006F006E003D007400720075006500008093530045004C0045004300540020005B00560061006C00750065005D002000460052004F004D00200043006F006400650066006C006F007700730043006F006E00660069006700750072006100740069006F006E0020005700480045005200450020005B004B00650079005D0020003D002000270057006F0072006B006500720045006E00640070006F0069006E0074002700018095540068006500720065002000770061007300200061006E0020006500720072006F00720020007700680069006C006500200074007200790069006E006700200074006F0020007200650061006400200077006F0072006B0065007200200065006E00640070006F0069006E007400200063006F006E00660069006700750072006100740069006F006E003A0020007B0030007D00006D43006F0075006C00640020006E006F0074002000660069006E0064002000740068006500200057006F0072006B006500720045006E00640070006F0069006E007400200063006F006E00660069006700750072006100740069006F006E00200065006E007400720079002E0000035C0000032F00005B43006F006E006600690067007500720065006400200077006F0072006B0065007200200065006E00640070006F0069006E00740020006900730020006E006F007400200061002000760061006C0069006400200055007200690000808D540068006500720065002000770061007300200061006E0020006500720072006F00720020007700680069006C006500200074007200790069006E006700200074006F002000640069007300700061007400630068002000740068006500200063006F006400650066006C006F007700200069006E007300740061006E00630065003A0020007B0030007D0000808549004E005300450052005400200049004E0054004F00200043006F006400650066006C006F00770073004C006F006700200028005B0044006100740061005D002C0020005B0054007900700065005D0029002000560041004C0055004500530020002800400044006100740061002C00200040004C006F00670054007900700065002900000B40004400610074006100001140004C006F006700540079007000650000808D540068006500720065002000770061007300200061006E0020006500720072006F00720020007700680069006C00650020007400720069006E006700200074006F0020006C006F006700200074006800650020006D006500730073006100670065003A0020007B0030007D002E00200045007800630065007000740069006F006E003A0020007B0031007D00000000602B94106C6CA74FB97F2C53A07DD3110008B77A5C561934E08902060803061108040000000004010000000402000000040300000007000201110D1008090003020E12111012150700020212151211040001010E060002010E1211080003010E1108121105000102121903200001042001010E042001010205200101114D04200101080320000E07070312111215020520010112110320001C0500020E0E1C042001020E0500020E0E0E090003020E11711012150B070612650E1219126502020620011D051215090705127512190E02020507021211020420001279062002127D0E1C032000080600030E0E1C1C09070412651265121902030701022001001B53716C536572766572436F6465666C6F7744697370617463686572000005010000000017010012436F7079726967687420C2A920203230313200000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301000000008EF71B4F000000000200000081000000583200005814000052534453223A6F8948EE1B4C9BDD0ADF70920D3721000000443A5C536F757263655C4765656B7364696172795C436F6465666C6F77735C7372635C53716C536572766572436F6465666C6F77446973706174636865725C6F626A5C44656275675C53716C536572766572436F6465666C6F77446973706174636865722E706462000000000433000000000000000000001E33000000200000000000000000000000000000000000000000000010330000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000700300000000000000000000700334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001005799341100000100579934113F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004D0020000010053007400720069006E006700460069006C00650049006E0066006F000000AC020000010030003000300030003000340062003000000060001C000100460069006C0065004400650073006300720069007000740069006F006E0000000000530071006C0053006500720076006500720043006F006400650066006C006F0077004400690073007000610074006300680065007200000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003400300034002E00330039003200350035000000000060002000010049006E007400650072006E0061006C004E0061006D0065000000530071006C0053006500720076006500720043006F006400650066006C006F00770044006900730070006100740063006800650072002E0064006C006C0000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003100320000006800200001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C0053006500720076006500720043006F006400650066006C006F00770044006900730070006100740063006800650072002E0064006C006C00000058001C000100500072006F0064007500630074004E0061006D00650000000000530071006C0053006500720076006500720043006F006400650066006C006F0077004400690073007000610074006300680065007200000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003400300034002E00330039003200350035000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003400300034002E0033003900320035003500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000303300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    WITH PERMISSION_SET = UNSAFE;


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Adding files to assembly [SqlServerCodeflowDispatcher]';


GO
ALTER ASSEMBLY [SqlServerCodeflowDispatcher]
    DROP FILE ALL
    ADD FILE FROM 0xEFBBBF7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446961676E6F73746963733B0D0A7573696E672053797374656D2E4E65743B0D0A7573696E672053797374656D2E52756E74696D652E496E7465726F7053657276696365733B0D0A7573696E672053797374656D2E53656375726974793B0D0A7573696E672053797374656D2E546872656164696E673B0D0A7573696E672053797374656D2E5472616E73616374696F6E733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A7573696E672053716C536572766572436F6465666C6F77446973706174636865723B0D0A0D0A2F2F205265536861727065722064697361626C65205061727469616C547970655769746853696E676C65506172740D0A7075626C6963207061727469616C20636C6173732053746F72656450726F636564757265730D0A2F2F2052655368617270657220726573746F7265205061727469616C547970655769746853696E676C65506172740D0A7B0D0A202020205B53716C50726F6365647572655D0D0A202020207075626C69632073746174696320766F6964204469737061746368436F6465666C6F77284775696420636F6465666C6F77496E7374616E636549642C206F757420696E7420726573756C74290D0A202020207B0D0A2020202020202020726573756C74203D20303B0D0A20202020202020207573696E67202876617220636F6E6E656374696F6E203D206E65772053716C436F6E6E656374696F6E2822636F6E7465787420636F6E6E656374696F6E3D747275652229290D0A20202020202020207B0D0A202020202020202020202020636F6E6E656374696F6E2E4F70656E28293B0D0A20202020202020202020202055726920776F726B6572456E64706F696E745572693B0D0A0D0A2020202020202020202020206966202821476574576F726B6572456E64706F696E7428636F6465666C6F77496E7374616E636549642E546F537472696E6728292C20636F6E6E656374696F6E2C206F757420776F726B6572456E64706F696E7455726929290D0A2020202020202020202020202020202072657475726E3B0D0A0D0A202020202020202020202020726573756C74203D204469737061746368436F726528776F726B6572456E64706F696E745572692C20636F6E6E656374696F6E29203F2031203A20303B0D0A20202020202020207D0D0A202020207D0D0A0D0A2020202073746174696320626F6F6C20476574576F726B6572456E64706F696E7428737472696E6720636F6465666C6F77496E7374616E636549642C2053716C436F6E6E656374696F6E20636F6E6E656374696F6E2C206F75742055726920776F726B6572456E64706F696E74557269290D0A202020207B0D0A2020202020202020776F726B6572456E64706F696E74557269203D206E756C6C3B0D0A0D0A202020202020202076617220636F6D6D616E64203D206E65772053716C436F6D6D616E640D0A20202020202020202020202020202020202020202020202020207B0D0A202020202020202020202020202020202020202020202020202020202020436F6E6E656374696F6E203D20636F6E6E656374696F6E2C0D0A202020202020202020202020202020202020202020202020202020202020436F6D6D616E6454657874203D202253454C454354205B56616C75655D2046524F4D20436F6465666C6F7773436F6E66696775726174696F6E205748455245205B4B65795D203D2027576F726B6572456E64706F696E7427220D0A20202020202020202020202020202020202020202020202020207D3B0D0A0D0A2020202020202020737472696E6720776F726B6572456E64706F696E74203D206E756C6C3B0D0A0D0A20202020202020207472790D0A20202020202020207B0D0A202020202020202020202020776F726B6572456E64706F696E74203D20636F6D6D616E642E457865637574655363616C6172282920617320737472696E673B0D0A20202020202020207D0D0A202020202020202063617463682028457863657074696F6E206578290D0A20202020202020207B0D0A202020202020202020202020696620284973466174616C28657829290D0A202020202020202020202020202020207468726F773B0D0A2020202020202020202020204C6F674572726F7228737472696E672E466F726D6174282254686572652077617320616E206572726F72207768696C6520747279696E6720746F207265616420776F726B657220656E64706F696E7420636F6E66696775726174696F6E3A207B307D222C206578292C0D0A202020202020202020202020202020202020202020636F6E6E656374696F6E293B0D0A20202020202020207D0D0A0D0A202020202020202069662028776F726B6572456E64706F696E74203D3D206E756C6C290D0A20202020202020207B0D0A2020202020202020202020204C6F674572726F722822436F756C64206E6F742066696E642074686520576F726B6572456E64706F696E7420636F6E66696775726174696F6E20656E7472792E222C20636F6E6E656374696F6E293B0D0A20202020202020202020202072657475726E2066616C73653B0D0A20202020202020207D0D0A0D0A2020202020202020776F726B6572456E64706F696E74202B3D20776F726B6572456E64706F696E742E456E64735769746828225C5C2229207C7C20776F726B6572456E64706F696E742E456E64735769746828222F22290D0A2020202020202020202020202020202020202020202020202020202020203F20636F6465666C6F77496E7374616E636549640D0A2020202020202020202020202020202020202020202020202020202020203A20222F22202B20636F6465666C6F77496E7374616E636549643B0D0A0D0A202020202020202069662028215572692E54727943726561746528776F726B6572456E64706F696E742C205572694B696E642E4162736F6C7574652C206F757420776F726B6572456E64706F696E7455726929290D0A20202020202020207B0D0A2020202020202020202020204C6F674572726F722822436F6E6669677572656420776F726B657220656E64706F696E74206973206E6F7420612076616C69642055726922293B0D0A20202020202020202020202072657475726E2066616C73653B0D0A20202020202020207D0D0A0D0A202020202020202072657475726E20747275653B0D0A202020207D0D0A0D0A2020202073746174696320626F6F6C204469737061746368436F72652855726920776F726B6572456E64706F696E742C2053716C436F6E6E656374696F6E20636F6E6E656374696F6E290D0A202020207B0D0A20202020202020207472790D0A20202020202020207B0D0A20202020202020202020202076617220636C69656E74203D206E657720576562436C69656E7428293B0D0A202020202020202020202020636C69656E742E446F776E6C6F61644461746128776F726B6572456E64706F696E74293B0D0A20202020202020202020202072657475726E20747275653B0D0A20202020202020207D0D0A202020202020202063617463682028457863657074696F6E206578290D0A20202020202020207B0D0A202020202020202020202020696620284973466174616C28657829290D0A202020202020202020202020202020207468726F773B0D0A0D0A202020202020202020202020766172206D657373616765203D20737472696E672E466F726D6174282254686572652077617320616E206572726F72207768696C6520747279696E6720746F2064697370617463682074686520636F6465666C6F7720696E7374616E63653A207B307D222C206578293B0D0A2020202020202020202020204C6F674572726F72286D6573736167652C20636F6E6E656374696F6E293B0D0A20202020202020207D0D0A0D0A202020202020202072657475726E2066616C73653B0D0A202020207D0D0A0D0A2020202073746174696320766F6964204C6F674572726F7228737472696E67206D657373616765290D0A202020207B0D0A20202020202020207573696E67202876617220636F6E6E656374696F6E203D206E65772053716C436F6E6E656374696F6E2829290D0A20202020202020207B0D0A202020202020202020202020636F6E6E656374696F6E2E4F70656E28293B0D0A2020202020202020202020204C6F674572726F72286D6573736167652C20636F6E6E656374696F6E293B0D0A20202020202020207D0D0A202020207D0D0A0D0A2020202073746174696320766F6964204C6F674572726F7228737472696E67206D6573736167652C2053716C436F6E6E656374696F6E20636F6E6E656374696F6E290D0A202020207B0D0A20202020202020204C6F67286D6573736167652C204C6F67547970652E4572726F722C20636F6E6E656374696F6E293B0D0A202020207D0D0A0D0A2020202073746174696320766F6964204C6F6728737472696E67206D6573736167652C204C6F6754797065206C6F67547970652C2053716C436F6E6E656374696F6E20636F6E6E656374696F6E290D0A202020207B0D0A20202020202020207472790D0A20202020202020207B0D0A20202020202020202020202076617220636F6D6D616E64203D206E65772053716C436F6D6D616E640D0A2020202020202020202020202020202020202020202020202020202020207B0D0A20202020202020202020202020202020202020202020202020202020202020202020436F6E6E656374696F6E203D20636F6E6E656374696F6E2C0D0A20202020202020202020202020202020202020202020202020202020202020202020436F6D6D616E6454657874203D2022494E5345525420494E544F20436F6465666C6F77734C6F6720285B446174615D2C205B547970655D292056414C554553202840446174612C20404C6F675479706529222C0D0A2020202020202020202020202020202020202020202020202020202020207D3B0D0A0D0A202020202020202020202020636F6D6D616E642E506172616D65746572732E4164645769746856616C756528224044617461222C206D657373616765293B0D0A202020202020202020202020636F6D6D616E642E506172616D65746572732E4164645769746856616C75652822404C6F6754797065222C206C6F6754797065293B0D0A202020202020202020202020636F6D6D616E642E457865637574654E6F6E517565727928293B0D0A20202020202020207D0D0A202020202020202063617463682028457863657074696F6E20657863657074696F6E290D0A20202020202020207B0D0A202020202020202020202020696620284973466174616C28657863657074696F6E29290D0A202020202020202020202020202020207468726F773B0D0A0D0A20202020202020202020202054726163652E577269746528737472696E672E466F726D6174282254686572652077617320616E206572726F72207768696C65207472696E6720746F206C6F6720746865206D6573736167653A207B307D2E20457863657074696F6E3A207B317D222C0D0A20202020202020202020202020202020202020202020202020202020202020202020202020206D6573736167652C0D0A2020202020202020202020202020202020202020202020202020202020202020202020202020657863657074696F6E29293B0D0A20202020202020207D0D0A202020207D0D0A0D0A0D0A2020202073746174696320626F6F6C204973466174616C28457863657074696F6E20657863657074696F6E290D0A202020207B0D0A202020202020202072657475726E2028657863657074696F6E2069732054687265616441626F7274457863657074696F6E207C7C0D0A20202020202020202020202020202020657863657074696F6E20697320534548457863657074696F6E207C7C0D0A20202020202020202020202020202020657863657074696F6E206973205365637572697479457863657074696F6E207C7C0D0A2020202020202020202020202020202028657863657074696F6E206973204F75744F664D656D6F7279457863657074696F6E202626202128657863657074696F6E20697320496E73756666696369656E744D656D6F7279457863657074696F6E2929293B0D0A202020207D0D0A7D3B AS N'DispatchCodeflow.cs', 0xEFBBBF6E616D6573706163652053716C536572766572436F6465666C6F77446973706174636865720D0A7B0D0A20202020656E756D204C6F67547970650D0A202020207B0D0A202020202020202056657273626F73652C0D0A2020202020202020496E666F726D6174696F6E2C0D0A20202020202020205761726E696E672C0D0A20202020202020204572726F720D0A202020207D0D0A7D AS N'LogType.cs', 0xEFBBBF7573696E672053797374656D2E5265666C656374696F6E3B0D0A7573696E672053797374656D2E52756E74696D652E436F6D70696C657253657276696365733B0D0A7573696E672053797374656D2E52756E74696D652E496E7465726F7053657276696365733B0D0A7573696E672053797374656D2E446174612E53716C3B0D0A0D0A2F2F2047656E6572616C20496E666F726D6174696F6E2061626F757420616E20617373656D626C7920697320636F6E74726F6C6C6564207468726F7567682074686520666F6C6C6F77696E670D0A2F2F20736574206F6620617474726962757465732E204368616E6765207468657365206174747269627574652076616C75657320746F206D6F646966792074686520696E666F726D6174696F6E0D0A2F2F206173736F636961746564207769746820616E20617373656D626C792E0D0A5B617373656D626C793A20417373656D626C795469746C65282253716C536572766572436F6465666C6F774469737061746368657222295D0D0A5B617373656D626C793A20417373656D626C794465736372697074696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6E66696775726174696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6D70616E79282222295D0D0A5B617373656D626C793A20417373656D626C7950726F64756374282253716C536572766572436F6465666C6F774469737061746368657222295D0D0A5B617373656D626C793A20417373656D626C79436F707972696768742822436F7079726967687420C2A920203230313222295D0D0A5B617373656D626C793A20417373656D626C7954726164656D61726B282222295D0D0A5B617373656D626C793A20417373656D626C7943756C74757265282222295D0D0A0D0A5B617373656D626C793A20436F6D56697369626C652866616C7365295D0D0A0D0A2F2F0D0A2F2F2056657273696F6E20696E666F726D6174696F6E20666F7220616E20617373656D626C7920636F6E7369737473206F662074686520666F6C6C6F77696E6720666F75722076616C7565733A0D0A2F2F0D0A2F2F2020202020204D616A6F722056657273696F6E0D0A2F2F2020202020204D696E6F722056657273696F6E0D0A2F2F2020202020204275696C64204E756D6265720D0A2F2F2020202020205265766973696F6E0D0A2F2F0D0A2F2F20596F752063616E207370656369667920616C6C207468652076616C756573206F7220796F752063616E2064656661756C7420746865205265766973696F6E20616E64204275696C64204E756D626572730D0A2F2F206279207573696E672074686520272A272061732073686F776E2062656C6F773A0D0A5B617373656D626C793A20417373656D626C7956657273696F6E2822312E302E2A22295D0D0A0D0A AS N'Properties\AssemblyInfo.cs', 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000020000001F00000010010000000000001D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020F9FFF9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF180200C6FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000000D00FFFF04000000038000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA3101380000000010000000100000000000000E00FFFF0400000003800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A7991000000000000000811391811A290770DF893D5F5612FDD5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF280000001C00000003000000060000001700000018000000070000000A00000009000000040000000C0000000D0000000E0000000F0000001000000011000000120000001300000014000000160000001500000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF040000000380000000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF040000000380000000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005502000000000000550200000000000000000000000000000000000000000000900D0000B80200002C00000060010000FFFFFFFF280000001C00000003000000060000001700000018000000070000000A00000009000000040000000C0000000D0000000E0000000F0000001000000011000000120000001300000014000000160000001500000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE2300180000000B9D3BA08FBD8CC01200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000200000001000000020000000000000055000000280000001BE230018562079558000000010000005400000055000000650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF01000000A800000000443A5C536F757263655C4765656B7364696172795C436F6465666C6F77735C7372635C53716C536572766572436F6465666C6F77446973706174636865725C4469737061746368436F6465666C6F772E63730000643A5C736F757263655C6765656B7364696172795C636F6465666C6F77735C7372635C73716C736572766572636F6465666C6F77646973706174636865725C6469737061746368636F6465666C6F772E63730004000000540000000100000055000000000000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE23001800000008070D0C2FBD8CC01210000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000200000001000000020000000000000055000000280000001BE230018562079558000000010000005400000055000000650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000003A002A11000000003002000000000000570000000000000000000000010000060000000001000000004469737061746368436F6465666C6F770000001600031104000000FC0100005700000000000000010000000A0024115553797374656D001A0024115553797374656D2E446174612E53716C436C69656E740000160024115553797374656D2E446961676E6F7374696373000E0024115553797374656D2E4E657400220024115553797374656D2E52756E74696D652E496E7465726F70536572766963657300160024115553797374656D2E536563757269747900000000160024115553797374656D2E546872656164696E670000001A0024115553797374656D2E5472616E73616374696F6E73000000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200220024115553716C536572766572436F6465666C6F7744697370617463686572000000001E002011020000000100001100000000000004004353243424303030300000001600031140000000F80100005100000004000000010000001E00201100000000010000110000000000000000636F6E6E656374696F6E0000160003117C010000F4010000330000000F000000010000002600201101000000010000110000000000000000776F726B6572456E64706F696E745572690000000200060002000600020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040000000C00000001000A00020006003A002A11000000009403000000000000D0000000000000000000000002000006570000000100000000476574576F726B6572456E64706F696E740000160003113402000060030000D000000057000000010000001E002011040000000200001100000000000004004353243124303030300000001E002011050000000200001100000000000004004353243424303030310000001A00201100000000020000110000000000000000636F6D6D616E64002200201101000000020000110000000000000000776F726B6572456E64706F696E74000022002011030000000200001100000000000000003C3E675F5F696E69744C6F63616C300016000311700200005C030000250000008A0000000100000016002011020000000200001100000000000000006578000002000600020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D004400320000000401000004013E0D0C000000010000060200060036002A1100000000E404000000000000460000000000000000000000030000062701000001000000004469737061746368436F72650000001600031198030000B00400004600000027010000010000001E002011030000000300001100000000000004004353243124303030300000001E0020110400000003000011000000000000040043532434243030303100000016000311D00300005C0400001300000028010000010000001A00201100000000030000110000000000000000636C69656E7400000200060016000311D0030000AC040000270000003C010000010000001600201101000000030000110000000000000000657800001A002011020000000300001100000000000000006D6573736167650002000600020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D004400320000000401000004013E0D0C000000010000060200060032002A1100000000C4050000000000002C0000000000000000000000040000066D01000001000000004C6F674572726F7200000016000311E8040000900500002C0000006D010000010000001E00201101000000040000110000000000000400435324342430303030000000160003111C0500008C0500002A0000006E010000010000001E00201100000000040000110000000000000000636F6E6E656374696F6E000002000600020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040100000C000000010000060200060032002A11000000002C060000000000000B0000000000000000000000050000069901000001000000004C6F674572726F720000002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040145000C00000001000006020006002E002A1100000000640700000000000079000000000000000000000006000006A401000001000000004C6F670000000016000311300600003007000079000000A4010000010000001E002011030000000500001100000000000004004353243424303030300000001600031160060000F00600004E000000A5010000010000001A00201100000000050000110000000000000000636F6D6D616E640022002011010000000500001100000000000000003C3E675F5F696E69744C6F63616C31000200060016000311600600002C07000023000000F6010000010000001E00201102000000050000110000000000000000657863657074696F6E00000002000600020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D00440032000000040100000401311C0C000000010000060200060032002A11000000000808000000000000380000000000000000000000070000061D02000001000000004973466174616C000000001600031168070000D4070000380000001D020000010000001E00201100000000060000110000000000000400435324312430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040145000C0000000100000602000600F2000000C0000000000000000100010057000000000000000E000000B40000000000000012000080010000001300008004000000140000800F00000015000080100000001600008017000000190000802D000000EEEFFE80300000001A000080320000001C000080410000001D00008042000000EEEFFE8054000000EEEFFE8055000000EEEFFE80560000001E000080050006000900140010004D0009000A000D001F000D00660000000000110018000D004A0009000A0000000000000000000000000005000600F2000000800100005700000001000100D0000000000000001E00000074010000000000002100008001000000220000800400000024000084200000002A000080220000002D000080230000002E0000802F0000002F00008030000000EEEFFE803200000030000080330000003100008034000000320000803F000000EEEFFE8043000000330000804500000034000081570000003600008058000000EEEFFE805A000000EEEFFE805B0000003800008064000000EEEFFE806800000039000080690000003A000080750000003B0000807A0000003E000082A900000042000080B3000000EEEFFE80B700000043000080B800000044000080C300000045000080C800000048000080CD00000049000080050006000900220009001D000900260009000A000D00400009000A000000000009001D0009000A000D001D0000000000110017000D00220009000A000000000000000000090024000000000009000A000D005C000D001A0009003A00090055000000000009000A000D0047000D001A000900150005000600F2000000F00000002701000001000100460000000000000012000000E4000000000000004C000080010000004E000080020000004F0000800800000050000080100000005100008014000000530000801500000054000080160000005500008021000000EEEFFE802500000056000080270000005800008033000000590000803B0000005A0000803C000000EEEFFE803E000000EEEFFE803F0000005C00008043000000EEEFFE80440000005D0000800500060009000A000D002A000D0031000D00190009001D0009000A000D001D0000000000110017000D0077000D002B0009000A000000000000000000090016000000000005000600F2000000840000006D010000010001002C00000000000000090000007800000000000000600000800100000061000080070000006200008008000000630000800F00000064000080170000006500008018000000EEEFFE802A000000EEEFFE802B00000066000080050006001000340009000A000D001F000D002B0009000A00000000000000000005000600F20000003C00000099010000010001000B0000000000000003000000300000000000000069000080010000006A0000800A0000006B000080050006000900310005000600F2000000F0000000A401000001000100790000000000000012000000E4000000000000006E000080010000007000008002000000710000841E00000077000080300000007800008047000000790000804E0000007A0000804F000000EEEFFE80510000007B000080520000007C000080530000007D0000805D000000EEEFFE80600000007E0000806200000080000082740000008300008075000000EEEFFE8077000000EEEFFE8078000000840000800500060009000A000D0021000D003F000D0042000D00270009000A00000000000900240009000A000D00240000000000110017000D00330009000A00000000000000000005000600F20000003C0000001D020000010001003800000000000000030000003000000000000000880000800100000089000083360000008D000080050006000900650005000600F40000000800000001000000000000003800000000000000200000003800000058000000700000008C000000A4000000BC000000D4000000EC0000000401000018010000300100004801000038000000000000000300000030000000000000008D000080010000008E0000833600000092000080050006000900650005000600F400000008000000010000000000000038000000000000002000000038000000FFFFFFFF1A092FF1700000003802000059000000010000008D00000001000000390000000100000021000000010000007100000001000000010000000100000019010000010000004901000001000000BD00000001000000ED000000010000000501000001000000D500000001000000A5000000010000003101000001000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000010000000000000020000000000000020000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000200000000000000000000000000C0000001800000024000000300000003C0000004800000054000000600000006C00000078000000840000009C000000000000000000000000000000000000004000000000000000000000000000000000000000000000000100000000000000200000000000000200000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001E002511000000000400000001004469737061746368436F6465666C6F7700001600291100000000040000000100303630303030303100001E00251100000000340200000100476574576F726B6572456E64706F696E74001600291100000000340200000100303630303030303200001A002511000000009803000001004469737061746368436F726500001600291100000000980300000100303630303030303300001600251100000000E804000001004C6F674572726F7200001600291100000000E80400000100303630303030303400001600251100000000C805000001004C6F674572726F7200001600291100000000C805000001003036303030303035000012002511000000003006000001004C6F6700000016002911000000003006000001003036303030303036000016002511000000006807000001004973466174616C0000001600291100000000680700000100303630303030303700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000020000000093050000FFFFFFFF1A092FF100000000000000000100303630303030303100001E00251100000000340200000100476574576F726B6572456E64706F696E74001600291100000000340200000100303630303030303200001A002511000000009803000001004469737061746368436F726500001600291100000000980300000100303630303030303300001600251100000000E804000001004C6F674572726F7200001600291100000000E80400000100303630303030303400001600251100000000C805000001004C6F674572726F7200001600291100000000C805000001003036303030303035000012002511000000003006000001004C6F6700000016002911000000003006000001003036303030303036000016002511000000006807000001004973466174616C00000016002911000000006807000001003036303030303037000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101210000000A00008B0B00189F0C007B425C000000C80000002C00000060000000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF00000000000000000000000009000C08000000000000640500000100000060D5AC0D000000000000000053746F72656450726F636564757265730043444135313336460000002DBA2EF1010000000000000057000000000000000000000000000000000000000100000057000000D00000000000000000000000000000000000000001000000270100004600000000000000000000000000000000000000010000006D0100002C0000000000000000000000000000000000000001000000990100000B0000000000000000000000000000000000000001000000A40100007900000000000000000000000000000000000000010000001D0200003800000000000000000000000000000000000000020002000D01000000000100FFFFFFFF00000000550200000802000000000000FFFFFFFF00000000FFFFFFFF010001000000010000000000443A5C536F757263655C4765656B7364696172795C436F6465666C6F77735C7372635C53716C536572766572436F6465666C6F77446973706174636865725C4469737061746368436F6465666C6F772E63730000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF2D00FFFFFFFFFFFFFFFFFFFF002C00000060000000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF00000000000000000000000009004408000000000000AC0500000100000080B5810C000000000000000053746F72656450726F636564757265730043444135313336460000002DBA2EF1010000000000000057000000000000000000000000000000000000000100000057000000D00000000000000000000000000000000000000001000000270100004600000000000000000000000000000000000000010000006D0100002C0000000000000000000000000000000000000001000000990100000B0000000000000000000000000000000000000001000000A4010000A00000000000000000000000000000000000000001000000440200003800000000000000000000000000000000000000020002000D01000000000100FFFFFFFF000000007C0200000802000000000000FFFFFFFF00000000FFFFFFFF010001000000010000000000443A5C536F757263655C4765656B7364696172795C436F6465666C6F77735C7372635C53716C536572766572436F6465666C6F77446973706174636865725C4469737061746368436F6465666C6F772E63730000FEEFFEEF010000000100000000010000090000000C010000DC00000038000000FFFFFFFF3800000000000000CC0000008000000058000000050000000300000006000000070000000A000000090000000400000072632F66696C65732F643A5C736F757263655C6765656B7364696172795C636F6465666C6F77735C7372635C73716C736572766572636F6465666C6F77646973706174636865725C6469737061746368636F6465666C6F772E6373000400000006000000010000001E00000000000000110000000700000022000000080000000A0000000600000000000000050000000000000041913201000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001900000020000000DC000000380000001F0200003800000000000000CC000000800000005800000028000000900D0000B80200002C000000600100000300000019000000060000001700000018000000070000000A0000000B00000008000000090000000C0000000D0000000E0000000F000000100000001100000012000000130000001400000016000000150000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E31010B94124F21000000223A6F8948EE1B4C9BDD0ADF70920D37800000002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F643A5C736F757263655C6765656B7364696172795C636F6465666C6F77735C7372635C73716C736572766572636F6465666C6F77646973706174636865725C6469737061746368636F6465666C6F772E6373000400000006000000010000001E00000000000000110000000700000022000000080000000A0000000600000000000000050000000000000041913201000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002E00000044000000DC000000380000001F0200003800000000000000CC0000008000000058000000AC0D0000B80200002C00000060010000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF28000000190000001B000000060000001700000018000000070000000A0000000B000000050000000C0000000D0000000E0000000F00000010000000110000001200000013000000140000001600000015000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001C00000044000000DC000000380000001F0200003800000000000000CC00000080000000580000002C0E0000B80200002C00000060010000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF28000000190000001C00000006000000180000001B000000070000000A00000009000000040000000C0000000D0000000E0000000F00000010000000110000001200000013000000140000001500000017000000160000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 AS N'..\..\scripts\SqlServerCodeflowDispatcher.pdb';


GO
PRINT N'Creating [dbo].[DispatchCodeflow]...';


GO
CREATE PROCEDURE [dbo].[DispatchCodeflow]
@codeflowInstanceId UNIQUEIDENTIFIER, @result INT OUTPUT
AS EXTERNAL NAME [SqlServerCodeflowDispatcher].[StoredProcedures].[DispatchCodeflow]


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Creating [SqlServerCodeflowDispatcher].[SqlAssemblyProjectRoot]...';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyProjectRoot', @value = N'D:\Source\Geeksdiary\Codeflows\src\SqlServerCodeflowDispatcher', @level0type = N'Assembly', @level0name = N'SqlServerCodeflowDispatcher';


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Creating [dbo].[DispatchCodeflow].[SqlAssemblyFile]...';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyFile', @value = N'DispatchCodeflow.cs', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'PROCEDURE', @level1name = N'DispatchCodeflow';


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
PRINT N'Creating [dbo].[DispatchCodeflow].[SqlAssemblyFileLine]...';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyFileLine', @value = N'18', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'PROCEDURE', @level1name = N'DispatchCodeflow';


GO
IF @@ERROR <> 0
   AND @@TRANCOUNT > 0
    BEGIN
        ROLLBACK;
    END

IF @@TRANCOUNT = 0
    BEGIN
        INSERT  INTO #tmpErrors (Error)
        VALUES                 (1);
        BEGIN TRANSACTION;
    END


GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT N'The transacted portion of the database update succeeded.'
COMMIT TRANSACTION
END
ELSE PRINT N'The transacted portion of the database update failed.'
GO
DROP TABLE #tmpErrors
GO
